--------------------------------------------------------------------------------
      name:  <unnamed>
       log:  D:\Dropbox\Work\Research\CreditCardABSRewrite\Draft\ReplicationFile
> s\Tab_11\Table_11_Log.log
  log type:  text
 opened on:   1 Jan 2022, 16:07:40

. 
. import delimited "Data_Table_11.csv"
(encoding automatically selected: ISO-8859-1)
(8 vars, 241 obs)

. 
. * generate ts index
. gen t = _n

. tsset t

Time variable: t, 1 to 241
        Delta: 1 unit

. 
. * generate indicators for subperiods
. generate pre=1 if year<2007
(157 missing values generated)

. generate cri=1 if year>2006 & year<2010
(205 missing values generated)

. generate post=1 if year>2009 & year<2021
(120 missing values generated)

. 
. 
. 
. * Table 1
. 
. *****************
. * A Tranche
. * All
. regress driskpremium_a dcdsissuer

      Source |       SS           df       MS      Number of obs   =       200
-------------+----------------------------------   F(1, 198)       =      6.16
       Model |  5769.38135         1  5769.38135   Prob > F        =    0.0139
    Residual |  185588.113       198  937.313701   R-squared       =    0.0301
-------------+----------------------------------   Adj R-squared   =    0.0253
       Total |  191357.494       199  961.595448   Root MSE        =    30.616

------------------------------------------------------------------------------
driskpremi~a | Coefficient  Std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
  dcdsissuer |   .2390907   .0963697     2.48   0.014      .049048    .4291335
       _cons |   .0950883   2.164854     0.04   0.965    -4.174041    4.364218
------------------------------------------------------------------------------

. loc AdjR2 = e(r2_a)

. newey2 driskpremium_a dcdsissuer, lag(4) force
No panel variable found. Time series assumed.


Regression with Newey-West standard errors          Number of obs  =       200
maximum lag : 4                                     F(  1,   198)  =      2.43
                                                    Prob > F       =    0.1205

------------------------------------------------------------------------------
             |             Newey-West
driskpremi~a | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
  dcdsissuer |   .2390907   .1533359     1.56   0.121    -.0632904    .5414718
       _cons |   .0950883   2.470728     0.04   0.969    -4.777231    4.967407
------------------------------------------------------------------------------

. outreg2 using Tab11_A, stats(coef tstat) noaster addstat(AdjR2, `AdjR2') title
> ("A Tranche") ctitle("All") drop(driskprem*) bdec(4) bfmt(f) tdec(2) tfmt(f) r
> dec(3) rfmt(f) label word replace
Tab11_A.rtf
dir : seeout

. * 2000-2006
. regress driskpremium_a dcdsissuer if pre==1

      Source |       SS           df       MS      Number of obs   =        64
-------------+----------------------------------   F(1, 62)        =      0.01
       Model |  3.64189415         1  3.64189415   Prob > F        =    0.9094
    Residual |  17300.2525        62  279.036331   R-squared       =    0.0002
-------------+----------------------------------   Adj R-squared   =   -0.0159
       Total |  17303.8944        63   274.66499   Root MSE        =    16.704

------------------------------------------------------------------------------
driskpremi~a | Coefficient  Std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
  dcdsissuer |  -.0360552   .3155979    -0.11   0.909    -.6669263     .594816
       _cons |  -.0066567   2.090671    -0.00   0.997    -4.185848    4.172534
------------------------------------------------------------------------------

. loc AdjR2 = e(r2_a)

. newey2 driskpremium_a dcdsissuer if pre==1, lag(4) force
No panel variable found. Time series assumed.


Regression with Newey-West standard errors          Number of obs  =        64
maximum lag : 4                                     F(  1,    62)  =      0.02
                                                    Prob > F       =    0.8780

------------------------------------------------------------------------------
             |             Newey-West
driskpremi~a | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
  dcdsissuer |  -.0360552   .2339304    -0.15   0.878    -.5036754    .4315651
       _cons |  -.0066567   1.577916    -0.00   0.997    -3.160866    3.147552
------------------------------------------------------------------------------

. outreg2 using Tab11_A, stats(coef tstat) noaster addstat(AdjR2, `AdjR2') title
> ("A Tranche") ctitle("2000-2006") drop(driskprem*) bdec(4) bfmt(f) tdec(2) tfm
> t(f) rdec(3) rfmt(f) label word 
Tab11_A.rtf
dir : seeout

. * 2007-2009
. regress driskpremium_a dcdsissuer if cri==1

      Source |       SS           df       MS      Number of obs   =        36
-------------+----------------------------------   F(1, 34)        =      1.24
       Model |  5961.13777         1  5961.13777   Prob > F        =    0.2731
    Residual |   163354.94        34  4804.55706   R-squared       =    0.0352
-------------+----------------------------------   Adj R-squared   =    0.0068
       Total |  169316.078        35  4837.60222   Root MSE        =    69.315

------------------------------------------------------------------------------
driskpremi~a | Coefficient  Std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
  dcdsissuer |   .2802954   .2516391     1.11   0.273    -.2310967    .7916875
       _cons |   1.558041    11.5651     0.13   0.894    -21.94507    25.06115
------------------------------------------------------------------------------

. loc AdjR2 = e(r2_a)

. newey2 driskpremium_a dcdsissuer if cri==1, lag(4) force
No panel variable found. Time series assumed.


Regression with Newey-West standard errors          Number of obs  =        36
maximum lag : 4                                     F(  1,    34)  =      1.84
                                                    Prob > F       =    0.1844

------------------------------------------------------------------------------
             |             Newey-West
driskpremi~a | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
  dcdsissuer |   .2802954   .2068598     1.36   0.184    -.1400944    .7006852
       _cons |   1.558041    13.6006     0.11   0.909    -26.08171    29.19779
------------------------------------------------------------------------------

. outreg2 using Tab11_A, stats(coef tstat) noaster addstat(AdjR2, `AdjR2') title
> ("A Tranche") ctitle("2007-2009") drop(driskprem*) bdec(4) bfmt(f) tdec(2) tfm
> t(f) rdec(3) rfmt(f) label word 
Tab11_A.rtf
dir : seeout

. * 2010-2020
. regress driskpremium_a dcdsissuer if post==1

      Source |       SS           df       MS      Number of obs   =       100
-------------+----------------------------------   F(1, 98)        =      8.15
       Model |  348.501269         1  348.501269   Prob > F        =    0.0053
    Residual |  4191.31849        98   42.768556   R-squared       =    0.0768
-------------+----------------------------------   Adj R-squared   =    0.0673
       Total |  4539.81976        99  45.8567652   Root MSE        =    6.5398

------------------------------------------------------------------------------
driskpremi~a | Coefficient  Std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
  dcdsissuer |   .1256997   .0440346     2.85   0.005     .0383144     .213085
       _cons |  -.5088159   .6542897    -0.78   0.439    -1.807233    .7896008
------------------------------------------------------------------------------

. loc AdjR2 = e(r2_a)

. newey2 driskpremium_a dcdsissuer if post==1, lag(4) force
No panel variable found. Time series assumed.


Regression with Newey-West standard errors          Number of obs  =       100
maximum lag : 4                                     F(  1,    98)  =      5.36
                                                    Prob > F       =    0.0226

------------------------------------------------------------------------------
             |             Newey-West
driskpremi~a | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
  dcdsissuer |   .1256997   .0542756     2.32   0.023     .0179916    .2334078
       _cons |  -.5088159   .5962998    -0.85   0.396    -1.692153    .6745218
------------------------------------------------------------------------------

. outreg2 using Tab11_A, stats(coef tstat) noaster addstat(AdjR2, `AdjR2') title
> ("A Tranche") ctitle("2010-2020") drop(driskprem*) bdec(4) bfmt(f) tdec(2) tfm
> t(f) rdec(3) rfmt(f) label word 
Tab11_A.rtf
dir : seeout

. 
. 
. *******************
. * B Tranche
. * All
. regress driskpremium_b dcdsissuer

      Source |       SS           df       MS      Number of obs   =       200
-------------+----------------------------------   F(1, 198)       =      1.90
       Model |  12911.9507         1  12911.9507   Prob > F        =    0.1702
    Residual |  1348861.56       198  6812.43215   R-squared       =    0.0095
-------------+----------------------------------   Adj R-squared   =    0.0045
       Total |  1361773.52       199  6843.08299   Root MSE        =    82.537

------------------------------------------------------------------------------
driskpremi~b | Coefficient  Std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
  dcdsissuer |   .3576795    .259806     1.38   0.170    -.1546625    .8700215
       _cons |   .1029546   5.836294     0.02   0.986    -11.40632    11.61223
------------------------------------------------------------------------------

. loc AdjR2 = e(r2_a)

. newey2 driskpremium_b dcdsissuer, lag(4) force
No panel variable found. Time series assumed.


Regression with Newey-West standard errors          Number of obs  =       200
maximum lag : 4                                     F(  1,   198)  =      0.20
                                                    Prob > F       =    0.6542

------------------------------------------------------------------------------
             |             Newey-West
driskpremi~b | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
  dcdsissuer |   .3576795   .7973829     0.45   0.654    -1.214773    1.930132
       _cons |   .1029546   8.016293     0.01   0.990    -15.70531    15.91122
------------------------------------------------------------------------------

. outreg2 using Tab11_B, stats(coef tstat) noaster addstat(AdjR2, `AdjR2') title
> ("B Tranche") ctitle("All")  drop(driskprem*) bdec(4) bfmt(f) tdec(2) tfmt(f) 
> rdec(3) rfmt(f) label word replace
Tab11_B.rtf
dir : seeout

. * 2000-2006
. regress driskpremium_b dcdsissuer if pre==1

      Source |       SS           df       MS      Number of obs   =        64
-------------+----------------------------------   F(1, 62)        =      0.10
       Model |  62.7852852         1  62.7852852   Prob > F        =    0.7515
    Residual |  38462.3758        62  620.360899   R-squared       =    0.0016
-------------+----------------------------------   Adj R-squared   =   -0.0145
       Total |  38525.1611        63  611.510493   Root MSE        =    24.907

------------------------------------------------------------------------------
driskpremi~b | Coefficient  Std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
  dcdsissuer |  -.1497037   .4705718    -0.32   0.751    -1.090363    .7909559
       _cons |  -.0695078   3.117292    -0.02   0.982    -6.300885     6.16187
------------------------------------------------------------------------------

. loc AdjR2 = e(r2_a)

. newey2 driskpremium_b dcdsissuer if pre==1, lag(4) force
No panel variable found. Time series assumed.


Regression with Newey-West standard errors          Number of obs  =        64
maximum lag : 4                                     F(  1,    62)  =      0.18
                                                    Prob > F       =    0.6697

------------------------------------------------------------------------------
             |             Newey-West
driskpremi~b | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
  dcdsissuer |  -.1497037   .3492382    -0.43   0.670     -.847821    .5484135
       _cons |  -.0695078   2.212788    -0.03   0.975    -4.492808    4.353793
------------------------------------------------------------------------------

. outreg2 using Tab11_B, stats(coef tstat) noaster addstat(AdjR2, `AdjR2') title
> ("B Tranche") ctitle("2000-2006") drop(driskprem*) bdec(4) bfmt(f) tdec(2) tfm
> t(f) rdec(3) rfmt(f) label word 
Tab11_B.rtf
dir : seeout

. * 2007-2009
. regress driskpremium_b dcdsissuer if cri==1

      Source |       SS           df       MS      Number of obs   =        36
-------------+----------------------------------   F(1, 34)        =      0.41
       Model |  15475.5974         1  15475.5974   Prob > F        =    0.5268
    Residual |  1286759.57        34  37845.8697   R-squared       =    0.0119
-------------+----------------------------------   Adj R-squared   =   -0.0172
       Total |  1302235.17        35   37206.719   Root MSE        =    194.54

------------------------------------------------------------------------------
driskpremi~b | Coefficient  Std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
  dcdsissuer |    .451622   .7062535     0.64   0.527    -.9836578    1.886902
       _cons |   5.217697   32.45876     0.16   0.873    -60.74645    71.18184
------------------------------------------------------------------------------

. loc AdjR2 = e(r2_a)

. newey2 driskpremium_b dcdsissuer if cri==1, lag(4) force
No panel variable found. Time series assumed.


Regression with Newey-West standard errors          Number of obs  =        36
maximum lag : 4                                     F(  1,    34)  =      0.16
                                                    Prob > F       =    0.6883

------------------------------------------------------------------------------
             |             Newey-West
driskpremi~b | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
  dcdsissuer |    .451622   1.116127     0.40   0.688     -1.81662    2.719864
       _cons |   5.217697   46.48479     0.11   0.911    -89.25077    99.68616
------------------------------------------------------------------------------

. outreg2 using Tab11_B, stats(coef tstat) noaster addstat(AdjR2, `AdjR2') title
> ("B Tranche") ctitle("2007-2009") drop(driskprem*) bdec(4) bfmt(f) tdec(2) tfm
> t(f) rdec(3) rfmt(f) label word 
Tab11_B.rtf
dir : seeout

. * 2010-2020
. regress driskpremium_b dcdsissuer if post==1

      Source |       SS           df       MS      Number of obs   =       100
-------------+----------------------------------   F(1, 98)        =      0.66
       Model |  128.583927         1  128.583927   Prob > F        =    0.4189
    Residual |  19120.3743        98   195.10586   R-squared       =    0.0067
-------------+----------------------------------   Adj R-squared   =   -0.0035
       Total |  19248.9582        99  194.433921   Root MSE        =    13.968

------------------------------------------------------------------------------
driskpremi~b | Coefficient  Std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
  dcdsissuer |   .0763529   .0940518     0.81   0.419    -.1102899    .2629956
       _cons |  -1.937559   1.397472    -1.39   0.169    -4.710796    .8356778
------------------------------------------------------------------------------

. loc AdjR2 = e(r2_a)

. newey2 driskpremium_b dcdsissuer if post==1, lag(4) force
No panel variable found. Time series assumed.


Regression with Newey-West standard errors          Number of obs  =       100
maximum lag : 4                                     F(  1,    98)  =      0.37
                                                    Prob > F       =    0.5453

------------------------------------------------------------------------------
             |             Newey-West
driskpremi~b | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
  dcdsissuer |   .0763529   .1257992     0.61   0.545    -.1732915    .3259973
       _cons |  -1.937559   1.461814    -1.33   0.188    -4.838481    .9633632
------------------------------------------------------------------------------

. outreg2 using Tab11_B, stats(coef tstat) noaster addstat(AdjR2, `AdjR2') title
> ("B Tranche") ctitle("2010-2020") drop(driskprem*) bdec(4) bfmt(f) tdec(2) tfm
> t(f) rdec(3) rfmt(f) label word 
Tab11_B.rtf
dir : seeout

. 
. 
. *******************
. * C Tranche
. * All
. regress driskpremium_c dcdsissuer

      Source |       SS           df       MS      Number of obs   =       200
-------------+----------------------------------   F(1, 198)       =      0.26
       Model |  4212.36364         1  4212.36364   Prob > F        =    0.6133
    Residual |  3256064.28       198  16444.7691   R-squared       =    0.0013
-------------+----------------------------------   Adj R-squared   =   -0.0038
       Total |  3260276.65       199  16383.2997   Root MSE        =    128.24

------------------------------------------------------------------------------
driskpremi~c | Coefficient  Std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
  dcdsissuer |   .2042965   .4036565     0.51   0.613    -.5917212    1.000314
       _cons |   .2570002   9.067759     0.03   0.977    -17.62478    18.13878
------------------------------------------------------------------------------

. loc AdjR2 = e(r2_a)

. newey2 driskpremium_c dcdsissuer, lag(4) force
No panel variable found. Time series assumed.


Regression with Newey-West standard errors          Number of obs  =       200
maximum lag : 4                                     F(  1,   198)  =      0.03
                                                    Prob > F       =    0.8671

------------------------------------------------------------------------------
             |             Newey-West
driskpremi~c | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
  dcdsissuer |   .2042965    1.21945     0.17   0.867    -2.200481    2.609074
       _cons |   .2570002   12.30407     0.02   0.983    -24.00683    24.52083
------------------------------------------------------------------------------

. outreg2 using Tab11_C, stats(coef tstat) noaster addstat(AdjR2, `AdjR2') title
> ("C Tranche") ctitle("All") drop(driskprem*) bdec(4) bfmt(f) tdec(2) tfmt(f) r
> dec(3) rfmt(f) label word replace
Tab11_C.rtf
dir : seeout

. * 2000-2006
. regress driskpremium_c dcdsissuer if pre==1

      Source |       SS           df       MS      Number of obs   =        64
-------------+----------------------------------   F(1, 62)        =      0.20
       Model |   303.43843         1   303.43843   Prob > F        =    0.6559
    Residual |  93823.4783        62  1513.28191   R-squared       =    0.0032
-------------+----------------------------------   Adj R-squared   =   -0.0129
       Total |  94126.9167        63  1494.07804   Root MSE        =    38.901

------------------------------------------------------------------------------
driskpremi~c | Coefficient  Std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
  dcdsissuer |  -.3291084   .7349599    -0.45   0.656    -1.798272    1.140055
       _cons |  -.3679976   4.868724    -0.08   0.940    -10.10044    9.364443
------------------------------------------------------------------------------

. loc AdjR2 = e(r2_a)

. newey2 driskpremium_c dcdsissuer if pre==1, lag(4) force
No panel variable found. Time series assumed.


Regression with Newey-West standard errors          Number of obs  =        64
maximum lag : 4                                     F(  1,    62)  =      0.39
                                                    Prob > F       =    0.5334

------------------------------------------------------------------------------
             |             Newey-West
driskpremi~c | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
  dcdsissuer |  -.3291084   .5254449    -0.63   0.533    -1.379458     .721241
       _cons |  -.3679976   3.597893    -0.10   0.919    -7.560083    6.824088
------------------------------------------------------------------------------

. outreg2 using Tab11_C, stats(coef tstat) noaster addstat(AdjR2, `AdjR2') title
> ("C Tranche") ctitle("2000-2006") drop(driskprem*) bdec(4) bfmt(f) tdec(2) tfm
> t(f) rdec(3) rfmt(f) label word 
Tab11_C.rtf
dir : seeout

. * 2007-2009
. regress driskpremium_c dcdsissuer if cri==1

      Source |       SS           df       MS      Number of obs   =        36
-------------+----------------------------------   F(1, 34)        =      0.05
       Model |    4803.018         1    4803.018   Prob > F        =    0.8203
    Residual |  3116739.84        34   91668.819   R-squared       =    0.0015
-------------+----------------------------------   Adj R-squared   =   -0.0278
       Total |  3121542.86        35  89186.9389   Root MSE        =    302.77

------------------------------------------------------------------------------
driskpremi~c | Coefficient  Std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
  dcdsissuer |   .2515988   1.099163     0.23   0.820     -1.98217    2.485367
       _cons |   8.688177   50.51653     0.17   0.864    -93.97377    111.3501
------------------------------------------------------------------------------

. loc AdjR2 = e(r2_a)

. newey2 driskpremium_c dcdsissuer if cri==1, lag(4) force
No panel variable found. Time series assumed.


Regression with Newey-West standard errors          Number of obs  =        36
maximum lag : 4                                     F(  1,    34)  =      0.02
                                                    Prob > F       =    0.8850

------------------------------------------------------------------------------
             |             Newey-West
driskpremi~c | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
  dcdsissuer |   .2515988   1.725872     0.15   0.885    -3.255796    3.758993
       _cons |   8.688177   71.78946     0.12   0.904    -137.2056    154.5819
------------------------------------------------------------------------------

. outreg2 using Tab11_C, stats(coef tstat) noaster addstat(AdjR2, `AdjR2') title
> ("C Tranche") ctitle("2007-2009") drop(driskprem*) bdec(4) bfmt(f) tdec(2) tfm
> t(f) rdec(3) rfmt(f) label word 
Tab11_C.rtf
dir : seeout

. * 2010-2020
. regress driskpremium_c dcdsissuer if post==1

      Source |       SS           df       MS      Number of obs   =       100
-------------+----------------------------------   F(1, 98)        =      0.28
       Model |  118.200201         1  118.200201   Prob > F        =    0.5951
    Residual |  40745.5367        98  415.770783   R-squared       =    0.0029
-------------+----------------------------------   Adj R-squared   =   -0.0073
       Total |  40863.7369        99  412.765019   Root MSE        =     20.39

------------------------------------------------------------------------------
driskpremi~c | Coefficient  Std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
  dcdsissuer |   .0732051   .1372964     0.53   0.595    -.1992551    .3456652
       _cons |  -2.588259   2.040022    -1.27   0.208    -6.636616    1.460097
------------------------------------------------------------------------------

. loc AdjR2 = e(r2_a)

. newey2 driskpremium_c dcdsissuer if post==1, lag(4) force
No panel variable found. Time series assumed.


Regression with Newey-West standard errors          Number of obs  =       100
maximum lag : 4                                     F(  1,    98)  =      0.17
                                                    Prob > F       =    0.6772

------------------------------------------------------------------------------
             |             Newey-West
driskpremi~c | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
  dcdsissuer |   .0732051   .1753276     0.42   0.677    -.2747268    .4211369
       _cons |  -2.588259    2.00679    -1.29   0.200    -6.570669     1.39415
------------------------------------------------------------------------------

. outreg2 using Tab11_C, stats(coef tstat) noaster addstat(AdjR2, `AdjR2') title
> ("C Tranche") ctitle("2010-2020") drop(driskprem*) bdec(4) bfmt(f) tdec(2) tfm
> t(f) rdec(3) rfmt(f) label word 
Tab11_C.rtf
dir : seeout

. 
. log close
      name:  <unnamed>
       log:  D:\Dropbox\Work\Research\CreditCardABSRewrite\Draft\ReplicationFile
> s\Tab_11\Table_11_Log.log
  log type:  text
 closed on:   1 Jan 2022, 16:07:48
--------------------------------------------------------------------------------
